﻿CREATE TABLE [dbo].[PredicaDetail] (
    [ID]                           INT           IDENTITY (1, 1) NOT NULL,
    [IDPredica]                    INT           NOT NULL,
    [MarimeSiteAudio]              INT           NOT NULL,
    [MarimeSiteEmisiuneAudio]      INT           NOT NULL,
    [MarimeSiteVideo]              INT           NOT NULL,
    [MarimeSiteEmisiuneVideo]      INT           NOT NULL,
    [FormatSiteAudio]              NVARCHAR (50) NULL,
    [FormatSiteEmisiuneAudio]      NVARCHAR (50) NULL,
    [FormatSiteVideo]              NVARCHAR (50) NULL,
    [FormatSiteEmisiuneVideo]      NVARCHAR (50) NULL,
    [IsAudio]                      BIT           NOT NULL,
    [IsVideo]                      BIT           NOT NULL,
    [IsEmisiuneAudio]              BIT           NOT NULL,
    [IsEmisiuneVideo]              BIT           NOT NULL,
    [IsCompArhivaVideo]            BIT           NOT NULL,
    [IsCompSiteVideo]              BIT           NOT NULL,
    [IsCompArhivaAudio]            BIT           NOT NULL,
    [IsCompArhivaAudioWithGeneric] BIT           NOT NULL
);

